prepare("select * from room_category where category_name = '$names'") ; $chk->execute(); if($chk->rowcount() > 0) { $msg = $names ."This Room Category is Already Registered, register another" ; } else { if($user->regrooms($cat,$names,$price,$adm)) { $msg = $names.'-'."Registered Successfully" ; } } } ?> Admin Panel

Dashboard

SET SERVICE DEFAULT VALUE

prepare("select * from rooms") ; $gtcat->execute() ; $count = 0 ; while($row = $gtcat->fetch(pdo::FETCH_ASSOC)) { $count++ ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; ?> " ; } ?>
SN CATEGORY NAME Room No Price/Night ACTIONS
".$count."".$row['Room_category']."".$row['Room_no']."".$row['Price']."EDIT|DELETE